﻿<TableSpec
	xmlns="bb_appfx_table"
	xmlns:common="bb_appfx_commontypes"
	ID="eda9efc8-b0c1-4c27-acc0-310aba25a506"
	Name="Service Bus Adapter Log"
	Description="Stores audit trail of all service bus adapter activity"
	Author="Blackbaud Professional Services"
	Tablename="USR_SERVICEBUSADAPTERLOG"
  EnableAuditTrail="false"
	>

  <!-- define fields on the table -->
  <Fields>
    <TextField Name="SERVERNAME" Required="true" Length="100" Description="The name of the server from which this log entry is being generated"/>
    <GuidField Name="CORRELATIONID" Required="true" Description="The correlation ID (workflow persistence ID) from the service operation"/>
    <EnumField Name="ENTRYTYPECODE" DefaultValue="4">
      <EnumValues>
        <EnumValue ID="1" Translation="Error" />
        <EnumValue ID="2" Translation="Warning" />
        <EnumValue ID="4" Translation="Information" />
      </EnumValues>
    </EnumField>
    <TextField Name="DETAILS" Length="4000" Description="Stores any details related to this log entry" />
    <DateField Name="LOGDATE" IncludeTime="true" Required="true" DefaultValue="GetDate()" Description="The date/time the log entry was created"/>
  </Fields>

  <!-- define any indexes on the table -->
  <Indexes>
    <Index>
      <IndexFields>
        <IndexField Name="LOGDATE"/>
      </IndexFields>
    </Index>
    <Index>
      <IndexFields>
        <IndexField Name="CORRELATIONID" />
      </IndexFields>
    </Index>
  </Indexes>

</TableSpec>
